| SaDynamicsErrorLog |
| EntityType | Independent |
| Logical Entity Name | SaDynamicsErrorLog |
| Default Table Name | SaDynamicsErrorLog |
| Logical Only | NO |
| Definition | |
| Note |
| SaDynamicsErrorLog Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
SaDynamicsErrorLogID |
INTEGER | NO | ||
SyCampusID |
INTEGER | NO | ||
| transdate | DATETIME | NO | ||
| FunctionalArea | VARCHAR(50) | NO | ||
| SourceTable | VARCHAR(50) | NO | ||
| SourceCode | VARCHAR(20) | NO | ||
| Comments | VARCHAR(300) | YES | ||
| SaBankDepID | INTEGER | YES | ||
| SaMiscCashID | INTEGER | YES | ||
| SaRevenueDetailID | INTEGER | YES | ||
| SaStudSubsidiaryTransID | INTEGER | YES | ||
| SaStudSubsidiaryAdjustID | INTEGER | YES | ||
| SaTransID | INTEGER | YES | ||
| SaTransAdjustID | INTEGER | YES | ||
| SyStudentID | INTEGER | YES | ||
| Ledger | VARCHAR(40) | NO | ||
| Reason | CHAR(1) | NO | ||
| UserID | INTEGER | NO | ||
| DateAdded | DATETIME | NO | ||
| DateLstMod | DATETIME | NO | ||
| ts | TIMESTAMP/DATE | NO | ||
| FiscalYear | VARCHAR(5) | YES | ||
| TransactionType | NVARCHAR(30) | YES | ||
| AxErrorLogId | INTEGER | YES |
| SaDynamicsErrorLog Keys |
| Key Name | Key Type | Keys |
| PK_SaDynamicsErrorLog_SaDynamicsErrorLogID | PrimaryKey | SaDynamicsErrorLogID |
| SaDynamicsErrorLog Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| Campus | Non-Identifying | One To Zero or More | SyCampusID | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| SaDynamicsErrorLog Check Constraints |
| Check Constraint Name | CheckConstraint |